Copyright: AC Olap Table Scripting Demo Help Version 1.1


Overview

The AC Olap Table Scripting Demo is a tool to use and test AC Olap Table using Visual Basic Scripting Edition scripts. It is installed automatically when installing AC Olap Table.

Also included are a number of example Visual Basic Scripting Edition scripts. These script files use the ACODemo database, an Oracle Express database for demo purposes, also included in the installation of AC Olap Table.

Copyright Information

Information in this online documentation is subject to change without notice. No part of this document may be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Alpha Centauri.

© 1997 Alpha Centauri All rights reserved.


Working with Visual Basic Scripting Edition script files

Visual Basic Scripting Edition script files are programs using Visual Basic Scripting Edition commands. To work with the AC Olap Table ActiveX you can use the AC Olap Table methods. More information on these methods you can find in the AC Olap Table Help .

Visual Basic Scripting Edition script files are normal text files with extension .vbs. You can create and edit them in the AC Olap Table Scripting Demo but also with any other text editor, e.g. Notepad.

Edit Visual Basic Scripting Edition script files

Run a Visual Basic Scripting Edition script file

Print a Visual Basic Scripting Edition script file

Reset the current settings

Generate Commands into the Visual Basic Scripting Edition script files


Generate Commands

The AC Olap Scripting Demo enables you to generate a few commands from the menu, i.e. those commands that make the connections to Oracle Express :

Generate the Connect command.

Generate the Disconnect command.

Generate the Open command.


Run a Visual Basic Scripting Edition script file

Click Run from the Edit menu

or

Click the [image] button.


Edit Visual Basic Scripting Edition script files

1) Click New from the File menu to create a new Visual Basic Scripting Edition script file

or

Click the [image] button.

2) Click Open from the File menu to open an existing Visual Basic Scripting Edition script file

or

Click the [image] button.

3) Click Save from the File menu to save the current Visual Basic Scripting Edition script file

or

Click the [image] button.

4) Click Save As from the File menu to save the current Visual Basic Scripting Edition script file under a new name.

5) Click Close from the File menu to close the current Visual Basic Scripting Edition script file.


Print a Visual Basic Scripting Edition script file

1) Click Print from the File menu to print the current Visual Basic Scripting Edition script file.

2) Click Print Preview from the File menu to display a print preview of the current Visual Basic Scripting Edition script file.

3) Click Print Setup from the File menu to modify the Printer settings.


Reset the current settings

Running Visual Basic Script files might initialize variables or events. Click Reset from the Edit menu

or

Click the [image] button to reset these settings.


Generate the Connect command

1) Open a new or an existing Visual Basic Scripting Edition script file

2) Click Generate Command from the Edit menu.

3) Select Connect

4) Select Local if you wish to open Oracle Personal Express

or

Select Remote if you wish to open Oracle Express Server.

5) The Connect command will be generated automatically in the Visual Basic Scripting Edition script file.


Generate the Disconnect command

1) Open a new or an existing Visual Basic Scripting Edition script file

2) Click Generate Command from the Edit menu.

3) Select Disconnect

4) The Disconnect command will be generated automatically in the Visual Basic Scripting Edition script file.


Generate the Open command

1) Open a new or an existing Visual Basic Scripting Edition script file

2) Click Generate Command from the Edit menu.

3) Select Open

4) Enter the name of an Express database. If the Express connection is a local connection you can click on the [image] button to select an existing Express database from the File Dialog box.

5) Check the Read Only box if the database should be attached Read Only.

6) Click the OK button and the Open command will be generated automatically in the Visual Basic Scripting Edition script file.


Trademark Information

AC Olap Table is a registered trademark of Alpha Centauri.

Oracle and Express are registered trademarks of Oracle Corporation. Personal Express and Express Server are trademarks of Oracle Corporation.

Visual Basic is a registered trademark of Microsoft Corporation.

Other products and company names may be trademarks of their respective owners.


Contact Alpha Centauri

Contact us via Post, Fax or E-Mail :

Alpha Centauri

Square Marlow 25

B-1180 Brussels

Belgium

E-Mail:	webmaster@alphacentauri.be

Fax:	+32 (0)2 340.12.41

Web:	http://www.alphacentauri.be


Technical Support

The Alpha Centauri support staff can help you with any problem you encounter or using the AC Olap Table Scripting Demo. If you need assistance, contact Alpha Centauri in any of the following ways:

For technical support contact:

E-Mail:	webmaster@alphacentauri.be

Fax:	+32 (0)2 340.12.41